package com.jxc.model.po;

import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;


@Entity
@Table(name="xstj")
public class Xstj extends IdEntity implements Serializable{
	/*create or replace view xstj as
	 * select u.id id,u.user_id userid, u.real_name realname,sum(oli.total) xssum 
	 * from xsgl_salelist_item oli,XSGL_SALELIST ol,qxgl_user u 
	 * where ol.id=oli.salelist_id and ol.user_id=u.id and  u.user_id in
	 * (select id from qxgl_user where user_type=1) group by userid
	 */
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private Long userid;
	private Double xssum;
	private String realname;
	@Column(name="userid")
	public Long getUserid() {
		return userid;
	}
	public void setUserid(Long userid) {
		this.userid = userid;
	}
	@Column(name="xssum")
	public Double getXssum() {
		return xssum;
	}
	public void setXssum(Double xssum) {
		this.xssum = xssum;
	}
	@Column(name="realname")
	public String getRealname() {
		return realname;
	}
	public void setRealname(String realname) {
		this.realname = realname;
	}
	
}
